Pandas Profiling Report

Dataset statistics

Number of variables	26
Number of observations	933973
Missing cells	158318
Missing cells (%)	0.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	531.3 MiB
Average record size in memory	596.5 B

Variable types

Numeric	11
Categorical	14
Boolean	1

Alerts

`insurance_amt` has constant value "0"	Constant
`finance_chgs` has constant value "0"	Constant
`installment_chgs` has constant value "0"	Constant
`tracker_chgs` has constant value "0"	Constant
`insurance_recv` has constant value "0"	Constant
`finance_chgs_recv` has constant value "0"	Constant
`installment_chgs_recv` has constant value "0"	Constant
`tracker_chgs_recv` has constant value "0"	Constant
`install_due_date` has a high cardinality: 3421 distinct values	High cardinality
`installment receiving date` has a high cardinality: 2403 distinct values	High cardinality
`Loan Settelment_Date` has a high cardinality: 99753 distinct values	High cardinality
`unit_id` is highly correlated with `insurance_amt` and 7 other fields	High correlation
`business_proposal_no` is highly correlated with `ProductDescription`	High correlation
`sub_proposal_no` is highly correlated with `insurance_amt` and 7 other fields	High correlation
`install_no` is highly correlated with `markup_amt`	High correlation
`principal_amt` is highly correlated with `markup_amt` and 3 other fields	High correlation
`markup_amt` is highly correlated with `principal_amt` and 4 other fields	High correlation
`principal_recv` is highly correlated with `principal_amt` and 3 other fields	High correlation
`markup_recv` is highly correlated with `principal_amt` and 5 other fields	High correlation
`os_principal` is highly correlated with `markup_recv` and 2 other fields	High correlation
`os_markup` is highly correlated with `markup_recv` and 1 other fields	High correlation
`session_id` is highly correlated with `business_proposal_no`	High correlation
`insurance_amt` is highly correlated with `Status` and 10 other fields	High correlation
`finance_chgs` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`installment_chgs` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`tracker_chgs` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`insurance_recv` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`finance_chgs_recv` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`installment_chgs_recv` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`tracker_chgs_recv` is highly correlated with `insurance_amt` and 10 other fields	High correlation
`os_install_flag` is highly correlated with `markup_amt` and 2 other fields	High correlation
`no_of_receipts` is highly correlated with `ProductDescription`	High correlation
`Status` is highly correlated with `os_install_flag`	High correlation
`ProductDescription` is highly correlated with `business_proposal_no` and 7 other fields	High correlation
`installment receiving date` has 158318 (17.0%) missing values	Missing
`session_id` is highly skewed (γ1 = 23.00611905)	Skewed
`principal_amt` has 30288 (3.2%) zeros	Zeros
`markup_amt` has 19212 (2.1%) zeros	Zeros
`principal_recv` has 178678 (19.1%) zeros	Zeros
`markup_recv` has 170046 (18.2%) zeros	Zeros
`os_principal` has 141632 (15.2%) zeros	Zeros
`os_markup` has 137489 (14.7%) zeros	Zeros

Reproduction

Analysis started	2022-11-08 09:10:23.008550
Analysis finished	2022-11-08 09:12:13.947584
Duration	1 minute and 50.94 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

unit_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	124
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2523.575249

Minimum	205
Maximum	9042
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	205
5-th percentile	217
Q1	319
median	612
Q3	708
95-th percentile	9039
Maximum	9042
Range	8837
Interquartile range (IQR)	389

Descriptive statistics

Standard deviation	3635.383255
Coefficient of variation (CV)	1.440568597
Kurtosis	-0.4937699652
Mean	2523.575249
Median Absolute Deviation (MAD)	208
Skewness	1.223100723
Sum	2356951146
Variance	13216011.41
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
703	106690	11.4%
301	51412	5.5%
701	43539	4.7%
603	42240	4.5%
9041	42141	4.5%
209	36038	3.9%
9003	33255	3.6%
612	24278	2.6%
305	22292	2.4%
313	21538	2.3%
Other values (114)	510550	54.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
205	1003	0.1%
209	36038	3.9%
210	1250	0.1%
213	2599	0.3%
214	2377	0.3%
216	2765	0.3%
217	1924	0.2%
218	2397	0.3%
219	7735	0.8%
220	2372	0.3%

Value	Count	Frequency (%)
9042	985	0.1%
9041	42141	4.5%
9040	2002	0.2%
9039	1885	0.2%
9038	2546	0.3%
9037	5447	0.6%
9036	4210	0.5%
9035	2195	0.2%
9034	1272	0.1%
9033	2074	0.2%

business_proposal_no
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	109476
Distinct (%)	11.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291064.8987

Minimum	2
Maximum	715816
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	2
5-th percentile	16094
Q1	103262
median	232598
Q3	533243
95-th percentile	625792
Maximum	715816
Range	715814
Interquartile range (IQR)	429981

Descriptive statistics

Standard deviation	211295.7082
Coefficient of variation (CV)	0.7259401911
Kurtosis	-1.331585463
Mean	291064.8987
Median Absolute Deviation (MAD)	163561
Skewness	0.3471036869
Sum	2.718467567 × 10¹¹
Variance	4.464587631 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
283637	88	< 0.1%
283902	87	< 0.1%
230686	84	< 0.1%
231371	83	< 0.1%
229665	81	< 0.1%
224689	81	< 0.1%
183371	81	< 0.1%
283765	80	< 0.1%
225871	80	< 0.1%
226547	79	< 0.1%
Other values (109466)	933149	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	30	< 0.1%
13	18	< 0.1%
24	18	< 0.1%
25	18	< 0.1%
46	12	< 0.1%
56	33	< 0.1%
75	15	< 0.1%
82	30	< 0.1%
103	18	< 0.1%
108	18	< 0.1%

Value	Count	Frequency (%)
715816	12	< 0.1%
714296	12	< 0.1%
711071	12	< 0.1%
710996	1	< 0.1%
710430	1	< 0.1%
709351	12	< 0.1%
709023	12	< 0.1%
707730	12	< 0.1%
707251	12	< 0.1%
705842	18	< 0.1%

sub_proposal_no
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.992615418

Minimum	1
Maximum	16
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	16
Range	15
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.564502029
Coefficient of variation (CV)	0.7851500168
Kurtosis	7.092219018
Mean	1.992615418
Median Absolute Deviation (MAD)	0
Skewness	2.351733863
Sum	1861049
Variance	2.447666599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	509346	54.5%
2	203954	21.8%
3	99244	10.6%
4	51413	5.5%
5	29937	3.2%
6	17245	1.8%
7	9968	1.1%
8	5515	0.6%
9	3396	0.4%
10	2003	0.2%
Other values (6)	1952	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	509346	54.5%
2	203954	21.8%
3	99244	10.6%
4	51413	5.5%
5	29937	3.2%
6	17245	1.8%
7	9968	1.1%
8	5515	0.6%
9	3396	0.4%
10	2003	0.2%

Value	Count	Frequency (%)
16	12	< 0.1%
15	24	< 0.1%
14	68	< 0.1%
13	269	< 0.1%
12	396	< 0.1%
11	1183	0.1%
10	2003	0.2%
9	3396	0.4%
8	5515	0.6%
7	9968	1.1%

install_no
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.79917942

Minimum	1
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	10
95-th percentile	15
Maximum	36
Range	35
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.502865684
Coefficient of variation (CV)	0.6622660481
Kurtosis	0.2945002387
Mean	6.79917942
Median Absolute Deviation (MAD)	4
Skewness	0.654949364
Sum	6350250
Variance	20.27579937
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=36)

Value	Count	Frequency (%)
1	137345	14.7%
2	69625	7.5%
3	66187	7.1%
4	65873	7.1%
5	65717	7.0%
6	65543	7.0%
7	65320	7.0%
8	65315	7.0%
9	65310	7.0%
10	65251	7.0%
Other values (26)	202487	21.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	137345	14.7%
2	69625	7.5%
3	66187	7.1%
4	65873	7.1%
5	65717	7.0%
6	65543	7.0%
7	65320	7.0%
8	65315	7.0%
9	65310	7.0%
10	65251	7.0%

Value	Count	Frequency (%)
36	1	< 0.1%
35	2	< 0.1%
34	7	< 0.1%
33	11	< 0.1%
32	12	< 0.1%
31	18	< 0.1%
30	20	< 0.1%
29	30	< 0.1%
28	73	< 0.1%
27	164	< 0.1%

install_due_date
Categorical

HIGH CARDINALITY

Distinct	3421
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	72.1 MiB

[2019/07/15:12:00:00 AM]	3770
[2019/11/11:12:00:00 AM]	3716
[2019/06/10:12:00:00 AM]	3637
[2019/09/10:12:00:00 AM]	3377
[2019/12/16:12:00:00 AM]	3366
Other values (3416)	916107

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	22415352
Distinct characters	17
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	397 ?
Unique (%)	< 0.1%

Sample

1st row	[2014/03/07:12:00:00 AM]
2nd row	[2014/04/07:12:00:00 AM]
3rd row	[2014/05/07:12:00:00 AM]
4th row	[2014/06/07:12:00:00 AM]
5th row	[2014/07/07:12:00:00 AM]

Common Values

Value	Count	Frequency (%)
[2019/07/15:12:00:00 AM]	3770	0.4%
[2019/11/11:12:00:00 AM]	3716	0.4%
[2019/06/10:12:00:00 AM]	3637	0.4%
[2019/09/10:12:00:00 AM]	3377	0.4%
[2019/12/16:12:00:00 AM]	3366	0.4%
[2019/08/10:12:00:00 AM]	3366	0.4%
[2019/10/10:12:00:00 AM]	3324	0.4%
[2019/08/15:12:00:00 AM]	3252	0.3%
[2019/07/10:12:00:00 AM]	3246	0.3%
[2019/01/10:12:00:00 AM]	3170	0.3%
Other values (3411)	899749	96.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
am	933973	50.0%
2019/07/15:12:00:00	3770	0.2%
2019/11/11:12:00:00	3716	0.2%
2019/06/10:12:00:00	3637	0.2%
2019/09/10:12:00:00	3377	0.2%
2019/12/16:12:00:00	3366	0.2%
2019/08/10:12:00:00	3366	0.2%
2019/10/10:12:00:00	3324	0.2%
2019/08/15:12:00:00	3252	0.2%
2019/07/10:12:00:00	3246	0.2%
Other values (3412)	902919	48.3%

Most occurring characters

Value	Count	Frequency (%)
0	6048323	27.0%
:	2801919	12.5%
1	2677045	11.9%
2	2501967	11.2%
/	1867946	8.3%
	933973	4.2%
]	933973	4.2%
M	933973	4.2%
A	933973	4.2%
[	933973	4.2%
Other values (7)	1848287	8.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	13075622	58.3%
Other Punctuation	4669865	20.8%
Uppercase Letter	1867946	8.3%
Space Separator	933973	4.2%
Close Punctuation	933973	4.2%
Open Punctuation	933973	4.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6048323	46.3%
1	2677045	20.5%
2	2501967	19.1%
9	458588	3.5%
8	354652	2.7%
5	308938	2.4%
6	215619	1.6%
7	187191	1.4%
4	168484	1.3%
3	154815	1.2%

Other Punctuation

Value	Count	Frequency (%)
:	2801919	60.0%
/	1867946	40.0%

Uppercase Letter

Value	Count	Frequency (%)
M	933973	50.0%
A	933973	50.0%

Space Separator

Value	Count	Frequency (%)
	933973	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	933973	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	20547406	91.7%
Latin	1867946	8.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6048323	29.4%
:	2801919	13.6%
1	2677045	13.0%
2	2501967	12.2%
/	1867946	9.1%
	933973	4.5%
]	933973	4.5%
[	933973	4.5%
9	458588	2.2%
8	354652	1.7%
Other values (5)	1035047	5.0%

Latin

Value	Count	Frequency (%)
M	933973	50.0%
A	933973	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22415352	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6048323	27.0%
:	2801919	12.5%
1	2677045	11.9%
2	2501967	11.2%
/	1867946	8.3%
	933973	4.2%
]	933973	4.2%
M	933973	4.2%
A	933973	4.2%
[	933973	4.2%
Other values (7)	1848287	8.2%

principal_amt
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	84625
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15623.19152

Minimum	0
Maximum	500000
Zeros	30288
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2748
Q1	4674
median	7245
Q3	11607.19
95-th percentile	100000
Maximum	500000
Range	500000
Interquartile range (IQR)	6933.19

Descriptive statistics

Standard deviation	27785.52698
Coefficient of variation (CV)	1.778479572
Kurtosis	12.88508692
Mean	15623.19152
Median Absolute Deviation (MAD)	2974.19
Skewness	3.570812243
Sum	1.459163906 × 10¹⁰
Variance	772035509.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	30288	3.2%
100000	20232	2.2%
150000	17931	1.9%
4231	6319	0.7%
4890	6314	0.7%
50000	5400	0.6%
3351	5287	0.6%
4755	5256	0.6%
3484	5248	0.6%
4574	5244	0.6%
Other values (84615)	826454	88.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	30288	3.2%
1.66	1	< 0.1%
8.31	1	< 0.1%
9	1	< 0.1%
9.62	1	< 0.1%
11.37	1	< 0.1%
12	1	< 0.1%
18.08	1	< 0.1%
21	1	< 0.1%
27.25	1	< 0.1%

Value	Count	Frequency (%)
500000	1	< 0.1%
400000	14	< 0.1%
390000	3	< 0.1%
325000	2	< 0.1%
320000	1	< 0.1%
300000	7	< 0.1%
260000	2	< 0.1%
252001.44	1	< 0.1%
250000	3	< 0.1%
228586.96	1	< 0.1%

markup_amt
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	95952
Distinct (%)	10.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4746.85931

Minimum	-5447
Maximum	169521
Zeros	19212
Zeros (%)	2.1%
Negative	308
Negative (%)	< 0.1%
Memory size	7.1 MiB

Quantile statistics

Minimum	-5447
5-th percentile	336
Q1	1102
median	1986.5
Q3	3781.4
95-th percentile	25632
Maximum	169521
Range	174968
Interquartile range (IQR)	2679.4

Descriptive statistics

Standard deviation	8919.5076
Coefficient of variation (CV)	1.879033487
Kurtosis	15.62255874
Mean	4746.85931
Median Absolute Deviation (MAD)	1147.5
Skewness	3.782780903
Sum	4433438430
Variance	79557615.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	19212	2.1%
934	5468	0.6%
447	5464	0.6%
1418	5404	0.6%
390	5304	0.6%
1263	5296	0.6%
1102	5293	0.6%
1567	5285	0.6%
578	5277	0.6%
1849	5260	0.6%
Other values (95942)	866710	92.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5447	1	< 0.1%
-4593	2	< 0.1%
-4354	1	< 0.1%
-3605	1	< 0.1%
-3595	1	< 0.1%
-3468	1	< 0.1%
-3257	1	< 0.1%
-3120	1	< 0.1%
-3047	1	< 0.1%
-3008	6	< 0.1%

Value	Count	Frequency (%)
169521	1	< 0.1%
141538	1	< 0.1%
136000	2	< 0.1%
132000	1	< 0.1%
130805	1	< 0.1%
128586.96	1	< 0.1%
115671	1	< 0.1%
114600	1	< 0.1%
114194	1	< 0.1%
114000	2	< 0.1%

insurance_amt
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

finance_chgs
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

installment_chgs
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

tracker_chgs
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

principal_recv
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	71739
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8648.759114

Minimum	0
Maximum	393699
Zeros	178678
Zeros (%)	19.1%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3484
median	5575
Q3	9237
95-th percentile	21199
Maximum	393699
Range	393699
Interquartile range (IQR)	5753

Descriptive statistics

Standard deviation	15916.15428
Coefficient of variation (CV)	1.840281833
Kurtosis	47.26952118
Mean	8648.759114
Median Absolute Deviation (MAD)	2889
Skewness	6.33987391
Sum	8077707496
Variance	253323966.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	178678	19.1%
4231	6264	0.7%
3351	5283	0.6%
3484	5242	0.6%
3622	5220	0.6%
3766	5211	0.6%
3915	5204	0.6%
4070	5194	0.6%
4399	5174	0.6%
4574	5048	0.5%
Other values (71729)	707455	75.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	178678	19.1%
0.38	1	< 0.1%
0.65	1	< 0.1%
1	1	< 0.1%
1.13	1	< 0.1%
1.25	1	< 0.1%
1.42	2	< 0.1%
1.5	1	< 0.1%
1.84	1	< 0.1%
3.4	2	< 0.1%

Value	Count	Frequency (%)
393699	1	< 0.1%
390000	1	< 0.1%
325000	2	< 0.1%
300335	1	< 0.1%
300000	1	< 0.1%
276976	1	< 0.1%
260000	1	< 0.1%
253180.75	1	< 0.1%
250000	1	< 0.1%
209918	1	< 0.1%

markup_recv
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	75161
Distinct (%)	8.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2842.69503

Minimum	-5447
Maximum	132000
Zeros	170046
Zeros (%)	18.2%
Negative	170
Negative (%)	< 0.1%
Memory size	7.1 MiB

Quantile statistics

Minimum	-5447
5-th percentile	0
Q1	615
median	1682.79
Q3	3134
95-th percentile	8006.91
Maximum	132000
Range	137447
Interquartile range (IQR)	2519

Descriptive statistics

Standard deviation	5358.862554
Coefficient of variation (CV)	1.885134528
Kurtosis	42.40248814
Mean	2842.69503
Median Absolute Deviation (MAD)	1224.79
Skewness	5.888681283
Sum	2655000406
Variance	28717407.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	170046	18.2%
1418	5381	0.6%
934	5308	0.6%
1567	5272	0.6%
1263	5258	0.6%
1849	5253	0.6%
1102	5238	0.6%
1711	5219	0.6%
759	5063	0.5%
578	4581	0.5%
Other values (75151)	717354	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5447	1	< 0.1%
-4593	2	< 0.1%
-3008	5	< 0.1%
-2783	4	< 0.1%
-2737	1	< 0.1%
-2604	1	< 0.1%
-2424	1	< 0.1%
-2282	2	< 0.1%
-2006	1	< 0.1%
-2000	1	< 0.1%

Value	Count	Frequency (%)
132000	1	< 0.1%
128586.96	1	< 0.1%
109578.42	1	< 0.1%
104701.44	1	< 0.1%
100750	1	< 0.1%
91616	1	< 0.1%
90893	1	< 0.1%
90314.38	1	< 0.1%
80255	1	< 0.1%
79532	1	< 0.1%

insurance_recv
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

finance_chgs_recv
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

installment_chgs_recv
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

tracker_chgs_recv
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	933973

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	933973	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	933973	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	933973	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	933973	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	933973	100.0%

os_principal
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	87864
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51540.6945

Minimum	-15198
Maximum	742642.32
Zeros	141632
Zeros (%)	15.2%
Negative	330
Negative (%)	< 0.1%
Memory size	7.1 MiB

Quantile statistics

Minimum	-15198
5-th percentile	0
Q1	14315.73
median	37545
Q3	70055
95-th percentile	157111
Maximum	742642.32
Range	757840.32
Interquartile range (IQR)	55739.27

Descriptive statistics

Standard deviation	57267.62988
Coefficient of variation (CV)	1.111114828
Kurtosis	8.958101204
Mean	51540.6945
Median Absolute Deviation (MAD)	26545.62
Skewness	2.471210633
Sum	4.813761706 × 10¹⁰
Variance	3279581432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	141632	15.2%
19162	5340	0.6%
46649	5222	0.6%
35777	5221	0.6%
43165	5221	0.6%
4890	5221	0.6%
9833	5221	0.6%
14588	5221	0.6%
23561	5221	0.6%
27792	5221	0.6%
Other values (87854)	745232	79.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-15198	4	< 0.1%
-14678	4	< 0.1%
-14043	4	< 0.1%
-13535	4	< 0.1%
-13128	4	< 0.1%
-12571	4	< 0.1%
-12228	4	< 0.1%
-11675	4	< 0.1%
-11253	4	< 0.1%
-10997	4	< 0.1%

Value	Count	Frequency (%)
742642.32	1	< 0.1%
683780.69	1	< 0.1%
638319	1	< 0.1%
625904.63	1	< 0.1%
623375.69	1	< 0.1%
613676.07	1	< 0.1%
601169.62	1	< 0.1%
587938.28	1	< 0.1%
575277.94	1	< 0.1%
561055.49	1	< 0.1%

os_markup
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	123635
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11012.99922

Minimum	-5447
Maximum	351841.81
Zeros	137489
Zeros (%)	14.7%
Negative	364
Negative (%)	< 0.1%
Memory size	7.1 MiB

Quantile statistics

Minimum	-5447
5-th percentile	0
Q1	1227
median	5806
Q3	13783
95-th percentile	39326.04
Maximum	351841.81
Range	357288.81
Interquartile range (IQR)	12556

Descriptive statistics

Standard deviation	16490.48086
Coefficient of variation (CV)	1.497365116
Kurtosis	25.79956055
Mean	11012.99922
Median Absolute Deviation (MAD)	5320
Skewness	3.946335704
Sum	1.028584392 × 10¹⁰
Variance	271935958.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	137489	14.7%
2174	5313	0.6%
6891	5292	0.6%
8458	5247	0.6%
1415	5235	0.6%
837	5228	0.6%
5473	5226	0.6%
3108	5225	0.6%
10169	5223	0.6%
4210	5223	0.6%
Other values (123625)	749272	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5447	1	< 0.1%
-4593	2	< 0.1%
-4354	1	< 0.1%
-3605	1	< 0.1%
-3595	1	< 0.1%
-3468	1	< 0.1%
-3284	1	< 0.1%
-3257	1	< 0.1%
-3120	1	< 0.1%
-3047	1	< 0.1%

Value	Count	Frequency (%)
351841.81	1	< 0.1%
342217.61	1	< 0.1%
336772.94	1	< 0.1%
324441.14	1	< 0.1%
321391.37	1	< 0.1%
308521.72	1	< 0.1%
306009.8	1	< 0.1%
292983.41	1	< 0.1%
291124.41	1	< 0.1%
287480	1	< 0.1%

os_install_flag
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	912.2 KiB

False	775656
True	158317

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	775656	83.0%
True	158317	17.0%

installment receiving date
Categorical

HIGH CARDINALITY
MISSING

Distinct	2403
Distinct (%)	0.3%
Missing	158318
Missing (%)	17.0%
Memory size	64.7 MiB

[2019/08/16:12:00:00 AM]	4432
[2019/04/15:12:00:00 AM]	3153
[2019/06/10:12:00:00 AM]	3118
[2019/09/11:12:00:00 AM]	3113
[2020/07/06:12:00:00 AM]	2931
Other values (2398)	758908

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	18615720
Distinct characters	17
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	192 ?
Unique (%)	< 0.1%

Sample

1st row	[2014/03/08:12:00:00 AM]
2nd row	[2014/04/07:12:00:00 AM]
3rd row	[2014/05/07:12:00:00 AM]
4th row	[2014/06/10:12:00:00 AM]
5th row	[2014/07/08:12:00:00 AM]

Common Values

Value	Count	Frequency (%)
[2019/08/16:12:00:00 AM]	4432	0.5%
[2019/04/15:12:00:00 AM]	3153	0.3%
[2019/06/10:12:00:00 AM]	3118	0.3%
[2019/09/11:12:00:00 AM]	3113	0.3%
[2020/07/06:12:00:00 AM]	2931	0.3%
[2018/06/19:12:00:00 AM]	2888	0.3%
[2019/02/11:12:00:00 AM]	2858	0.3%
[2019/09/16:12:00:00 AM]	2854	0.3%
[2019/07/15:12:00:00 AM]	2818	0.3%
[2019/08/19:12:00:00 AM]	2747	0.3%
Other values (2393)	744743	79.7%
(Missing)	158318	17.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
am	775655	50.0%
2019/08/16:12:00:00	4432	0.3%
2019/04/15:12:00:00	3153	0.2%
2019/06/10:12:00:00	3118	0.2%
2019/09/11:12:00:00	3113	0.2%
2020/07/06:12:00:00	2931	0.2%
2018/06/19:12:00:00	2888	0.2%
2019/02/11:12:00:00	2858	0.2%
2019/09/16:12:00:00	2854	0.2%
2019/07/15:12:00:00	2818	0.2%
Other values (2394)	747490	48.2%

Most occurring characters

Value	Count	Frequency (%)
0	4918669	26.4%
:	2326965	12.5%
1	2221800	11.9%
2	2086627	11.2%
/	1551310	8.3%
	775655	4.2%
]	775655	4.2%
M	775655	4.2%
A	775655	4.2%
[	775655	4.2%
Other values (7)	1632074	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10859170	58.3%
Other Punctuation	3878275	20.8%
Uppercase Letter	1551310	8.3%
Space Separator	775655	4.2%
Close Punctuation	775655	4.2%
Open Punctuation	775655	4.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4918669	45.3%
1	2221800	20.5%
2	2086627	19.2%
9	397592	3.7%
8	334136	3.1%
5	225466	2.1%
6	194007	1.8%
7	185891	1.7%
4	151315	1.4%
3	143667	1.3%

Other Punctuation

Value	Count	Frequency (%)
:	2326965	60.0%
/	1551310	40.0%

Uppercase Letter

Value	Count	Frequency (%)
M	775655	50.0%
A	775655	50.0%

Space Separator

Value	Count	Frequency (%)
	775655	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	775655	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	775655	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	17064410	91.7%
Latin	1551310	8.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4918669	28.8%
:	2326965	13.6%
1	2221800	13.0%
2	2086627	12.2%
/	1551310	9.1%
	775655	4.5%
]	775655	4.5%
[	775655	4.5%
9	397592	2.3%
8	334136	2.0%
Other values (5)	900346	5.3%

Latin

Value	Count	Frequency (%)
M	775655	50.0%
A	775655	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18615720	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4918669	26.4%
:	2326965	12.5%
1	2221800	11.9%
2	2086627	11.2%
/	1551310	8.3%
	775655	4.2%
]	775655	4.2%
M	775655	4.2%
A	775655	4.2%
[	775655	4.2%
Other values (7)	1632074	8.8%

no_of_receipts
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

0	543315
1	388385
77	2273

Length

Max length	2
Median length	1
Mean length	1.002433689
Min length	1

Characters and Unicode

Total characters	936246
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	543315	58.2%
1	388385	41.6%
77	2273	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	543315	58.2%
1	388385	41.6%
77	2273	0.2%

Most occurring characters

Value	Count	Frequency (%)
0	543315	58.0%
1	388385	41.5%
7	4546	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	936246	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	543315	58.0%
1	388385	41.5%
7	4546	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	936246	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	543315	58.0%
1	388385	41.5%
7	4546	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	936246	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	543315	58.0%
1	388385	41.5%
7	4546	0.5%

session_id
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	88569
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1300791.729

Minimum	7
Maximum	99099099
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.1 MiB

Quantile statistics

Minimum	7
5-th percentile	34663
Q1	439770
median	586951
Q3	1769027
95-th percentile	3904137
Maximum	99099099
Range	99099092
Interquartile range (IQR)	1329257

Descriptive statistics

Standard deviation	3827095.925
Coefficient of variation (CV)	2.94212812
Kurtosis	584.1910437
Mean	1300791.729
Median Absolute Deviation (MAD)	436499
Skewness	23.00611905
Sum	1.214904354 × 10¹²
Variance	1.464666322 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
586951	97616	10.5%
439798	43060	4.6%
439797	37710	4.0%
500039	37179	4.0%
499665	33086	3.5%
653770	32044	3.4%
439770	27814	3.0%
546389	19131	2.0%
34635	8490	0.9%
34671	8199	0.9%
Other values (88559)	589644	63.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7	3989	0.4%
235	1	< 0.1%
285	1	< 0.1%
389	2	< 0.1%
404	22	< 0.1%
460	2	< 0.1%
753	1	< 0.1%
837	5	< 0.1%
898	3	< 0.1%
945	1	< 0.1%

Value	Count	Frequency (%)
99099099	1286	0.1%
20200311	1	< 0.1%
4721204	1	< 0.1%
4721132	1	< 0.1%
4721004	4	< 0.1%
4720970	2	< 0.1%
4720693	2	< 0.1%
4720590	1	< 0.1%
4720547	2	< 0.1%
4720530	1	< 0.1%

Status
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	51.7 MiB

E	573814
X	360159

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	933973
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	X
2nd row	X
3rd row	X
4th row	X
5th row	X

Common Values

Value	Count	Frequency (%)
E	573814	61.4%
X	360159	38.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
e	573814	61.4%
x	360159	38.6%

Most occurring characters

Value	Count	Frequency (%)
E	573814	61.4%
X	360159	38.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	933973	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	573814	61.4%
X	360159	38.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	933973	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	573814	61.4%
X	360159	38.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	933973	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	573814	61.4%
X	360159	38.6%

Loan Settelment_Date
Categorical

HIGH CARDINALITY

Distinct	99753
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Memory size	72.1 MiB

[2018/06/19:12:00:00 AM]	902
[2019/11/14:12:00:00 AM]	893
[2018/02/28:12:00:00 AM]	818
[2018/12/31:12:00:00 AM]	787
[2018/11/12:12:00:00 AM]	749
Other values (99748)	929824

Length

Max length	24
Median length	24
Mean length	24
Min length	24

Characters and Unicode

Total characters	22415352
Distinct characters	18
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	53149 ?
Unique (%)	5.7%

Sample

1st row	[2015/02/16:12:00:00 AM]
2nd row	[2015/02/16:12:00:00 AM]
3rd row	[2015/02/16:12:00:00 AM]
4th row	[2015/02/16:12:00:00 AM]
5th row	[2015/02/16:12:00:00 AM]

Common Values

Value	Count	Frequency (%)
[2018/06/19:12:00:00 AM]	902	0.1%
[2019/11/14:12:00:00 AM]	893	0.1%
[2018/02/28:12:00:00 AM]	818	0.1%
[2018/12/31:12:00:00 AM]	787	0.1%
[2018/11/12:12:00:00 AM]	749	0.1%
[2018/10/17:12:00:00 AM]	744	0.1%
[2019/11/15:12:00:00 AM]	715	0.1%
[2016/10/17:12:00:00 AM]	705	0.1%
[2018/07/17:12:00:00 AM]	704	0.1%
[2018/04/30:12:00:00 AM]	701	0.1%
Other values (99743)	926255	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
am	516327	27.6%
pm	417646	22.4%
2018/06/19:12:00:00	902	< 0.1%
2019/11/14:12:00:00	893	< 0.1%
2018/02/28:12:00:00	818	< 0.1%
2018/12/31:12:00:00	787	< 0.1%
2018/11/12:12:00:00	749	< 0.1%
2018/10/17:12:00:00	744	< 0.1%
2019/11/15:12:00:00	715	< 0.1%
2016/10/17:12:00:00	705	< 0.1%
Other values (99729)	927660	49.7%

Most occurring characters

Value	Count	Frequency (%)
0	4373506	19.5%
:	2801919	12.5%
2	2572566	11.5%
1	2571689	11.5%
/	1867946	8.3%
[	933973	4.2%
]	933973	4.2%
M	933973	4.2%
	933973	4.2%
9	678044	3.0%
Other values (8)	3813790	17.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	13075622	58.3%
Other Punctuation	4669865	20.8%
Uppercase Letter	1867946	8.3%
Open Punctuation	933973	4.2%
Close Punctuation	933973	4.2%
Space Separator	933973	4.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4373506	33.4%
2	2572566	19.7%
1	2571689	19.7%
9	678044	5.2%
5	599821	4.6%
3	596840	4.6%
4	554704	4.2%
8	447844	3.4%
6	377475	2.9%
7	303133	2.3%

Uppercase Letter

Value	Count	Frequency (%)
M	933973	50.0%
A	516327	27.6%
P	417646	22.4%

Other Punctuation

Value	Count	Frequency (%)
:	2801919	60.0%
/	1867946	40.0%

Open Punctuation

Value	Count	Frequency (%)
[	933973	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	933973	100.0%

Space Separator

Value	Count	Frequency (%)
	933973	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	20547406	91.7%
Latin	1867946	8.3%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4373506	21.3%
:	2801919	13.6%
2	2572566	12.5%
1	2571689	12.5%
/	1867946	9.1%
[	933973	4.5%
]	933973	4.5%
	933973	4.5%
9	678044	3.3%
5	599821	2.9%
Other values (5)	2279996	11.1%

Latin

Value	Count	Frequency (%)
M	933973	50.0%
A	516327	27.6%
P	417646	22.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	22415352	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4373506	19.5%
:	2801919	12.5%
2	2572566	11.5%
1	2571689	11.5%
/	1867946	8.3%
[	933973	4.2%
]	933973	4.2%
M	933973	4.2%
	933973	4.2%
9	678044	3.0%
Other values (8)	3813790	17.0%

ProductDescription
Categorical

HIGH CORRELATION

Distinct	36
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	76.4 MiB

FINCA KAROBARI KARZA BASIC	369917
FINCA KAROBARI KARZA BASIC 12 MONTHS	141831
FINCA MAWESHI KARZA BASIC	90532
FINCA MAWESHI KARZA BASIC 12 MONTHS	70989
FINCA KAROBARI KARZA PLUS	50756
Other values (31)	209948

Length

Max length	45
Median length	44
Mean length	28.81792514
Min length	18

Characters and Unicode

Total characters	26915164
Distinct characters	33
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FINCA KAROBARI KARZA BASIC
2nd row	FINCA KAROBARI KARZA BASIC
3rd row	FINCA KAROBARI KARZA BASIC
4th row	FINCA KAROBARI KARZA BASIC
5th row	FINCA KAROBARI KARZA BASIC

Common Values

Value	Count	Frequency (%)
FINCA KAROBARI KARZA BASIC	369917	39.6%
FINCA KAROBARI KARZA BASIC 12 MONTHS	141831	15.2%
FINCA MAWESHI KARZA BASIC	90532	9.7%
FINCA MAWESHI KARZA BASIC 12 MONTHS	70989	7.6%
FINCA KAROBARI KARZA PLUS	50756	5.4%
FINCA KASHTKAR KARZA BASIC	45007	4.8%
FINCA MAWESHI KARZA FATTENING	28344	3.0%
FINCA MAWESHI KARZA PLUS	27961	3.0%
FINCA NISWAN KARZA 12 MONTHS	23058	2.5%
FINCA KAROBARI KARZA PLUS 12 MONTHS	21674	2.3%
Other values (26)	63904	6.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
finca	933537	21.5%
karza	933443	21.5%
basic	735567	17.0%
karobari	604192	13.9%
months	316447	7.3%
12	273640	6.3%
maweshi	246297	5.7%
plus	131844	3.0%
kashtkar	46984	1.1%
niswan	33032	0.8%
Other values (21)	79465	1.8%

Most occurring characters

Value	Count	Frequency (%)
A	5154578	19.2%
	3428496	12.7%
I	2587057	9.6%
R	2189035	8.1%
C	1669540	6.2%
K	1631603	6.1%
S	1513007	5.6%
N	1373406	5.1%
B	1339795	5.0%
F	966752	3.6%
Other values (23)	5061895	18.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	22863102	84.9%
Space Separator	3428496	12.7%
Decimal Number	623347	2.3%
Dash Punctuation	161	< 0.1%
Other Punctuation	58	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	5154578	22.5%
I	2587057	11.3%
R	2189035	9.6%
C	1669540	7.3%
K	1631603	7.1%
S	1513007	6.6%
N	1373406	6.0%
B	1339795	5.9%
F	966752	4.2%
Z	936381	4.1%
Other values (13)	3501948	15.3%

Decimal Number

Value	Count	Frequency (%)
1	306361	49.1%
2	274143	44.0%
8	18554	3.0%
5	14167	2.3%
6	9583	1.5%
4	503	0.1%
3	36	< 0.1%

Space Separator

Value	Count	Frequency (%)
	3428496	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	161	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	58	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22863102	84.9%
Common	4052062	15.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	5154578	22.5%
I	2587057	11.3%
R	2189035	9.6%
C	1669540	7.3%
K	1631603	7.1%
S	1513007	6.6%
N	1373406	6.0%
B	1339795	5.9%
F	966752	4.2%
Z	936381	4.1%
Other values (13)	3501948	15.3%

Common

Value	Count	Frequency (%)
	3428496	84.6%
1	306361	7.6%
2	274143	6.8%
8	18554	0.5%
5	14167	0.3%
6	9583	0.2%
4	503	< 0.1%
-	161	< 0.1%
/	58	< 0.1%
3	36	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26915164	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	5154578	19.2%
	3428496	12.7%
I	2587057	9.6%
R	2189035	8.1%
C	1669540	6.2%
K	1631603	6.1%
S	1513007	5.6%
N	1373406	5.1%
B	1339795	5.0%
F	966752	3.6%
Other values (23)	5061895	18.8%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	unit_id	business_proposal_no	sub_proposal_no	install_no	install_due_date	principal_amt	markup_amt	principal_recv	markup_recv	os_principal	os_markup	os_install_flag	installment receiving date	session_id	Status	Loan Settelment_Date	ProductDescription
0	209	592737	6	1	[2014/03/07:12:00:00 AM]	3469.0	1881.0	3469.0	1881.0	46531.0	12369.0	N	[2014/03/08:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
1	209	592737	6	2	[2014/04/07:12:00:00 AM]	3412.0	1938.0	3412.0	1938.0	43119.0	10431.0	N	[2014/04/07:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
2	209	592737	6	3	[2014/05/07:12:00:00 AM]	3612.0	1738.0	3612.0	1738.0	39507.0	8693.0	N	[2014/05/07:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
3	209	592737	6	4	[2014/06/07:12:00:00 AM]	3705.0	1645.0	3705.0	1645.0	35802.0	7048.0	N	[2014/06/10:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
4	209	592737	6	5	[2014/07/07:12:00:00 AM]	3907.0	1443.0	3907.0	1443.0	31895.0	5605.0	N	[2014/07/08:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
5	209	592737	6	6	[2014/08/07:12:00:00 AM]	4022.0	1328.0	4022.0	1328.0	27873.0	4277.0	N	[2014/08/08:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
6	209	592737	6	7	[2014/09/07:12:00:00 AM]	4189.0	1161.0	4189.0	1161.0	23684.0	3116.0	N	[2014/09/11:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
7	209	592737	6	8	[2014/10/07:12:00:00 AM]	4396.0	954.0	4396.0	954.0	19288.0	2162.0	N	[2014/10/15:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
8	209	592737	6	9	[2014/11/07:12:00:00 AM]	4547.0	803.0	4547.0	803.0	14741.0	1359.0	N	[2014/11/11:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC
9	209	592737	6	10	[2014/12/07:12:00:00 AM]	4756.0	594.0	4756.0	594.0	9985.0	765.0	N	[2014/12/11:12:00:00 AM]	653770	X	[2015/02/16:12:00:00 AM]	FINCA KAROBARI KARZA BASIC

Last rows

	unit_id	business_proposal_no	sub_proposal_no	install_no	install_due_date	principal_amt	markup_amt	os_principal	os_markup	os_install_flag	installment receiving date	session_id	Status	Loan Settelment_Date	ProductDescription
933963	9042	697959	1	3	[2020/10/23:12:00:00 AM]	7163.82	3670.18	79639.02	17858.98	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933964	9042	697959	1	4	[2020/11/23:12:00:00 AM]	7354.48	3479.52	72284.54	14379.46	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933965	9042	697959	1	5	[2020/12/23:12:00:00 AM]	7777.68	3056.32	64506.86	11323.14	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933966	9042	697959	1	6	[2021/01/23:12:00:00 AM]	8015.62	2818.38	56491.24	8504.76	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933967	9042	697959	1	7	[2021/02/23:12:00:00 AM]	8365.83	2468.17	48125.41	6036.59	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933968	9042	697959	1	8	[2021/03/23:12:00:00 AM]	8934.83	1899.17	39190.58	4137.42	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933969	9042	697959	1	9	[2021/04/23:12:00:00 AM]	9121.72	1712.28	30068.86	2425.14	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933970	9042	697959	1	10	[2021/05/24:12:00:00 AM]	9520.26	1313.74	20548.60	1111.40	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933971	9042	697959	1	11	[2021/06/23:12:00:00 AM]	9965.17	868.83	10583.43	242.57	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS
933972	9042	697959	1	12	[2021/07/23:12:00:00 AM]	10583.43	242.57	0.00	0.00	Y	NaN	4011582	E	[2020/09/24:04:28:36 PM]	FINCA KAROBARI KARZA BASIC 12 MONTHS

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Uppercase Letter

Space Separator

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts